
-- ----------------------------
-- Table structure for sys_action_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_action_log`;
CREATE TABLE `sys_action_log` (
  `al_id` int(11) NOT NULL AUTO_INCREMENT,
  `al_uid` int(11) DEFAULT '0' COMMENT '操作用户ID',
  `al_name` varchar(60) DEFAULT NULL COMMENT '操作的名称',
  `al_create_time` int(11) DEFAULT '0' COMMENT '操作时间',
  PRIMARY KEY (`al_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='系统操作日志表';

-- ----------------------------
-- Records of sys_action_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_action_permissions
-- ----------------------------
DROP TABLE IF EXISTS `sys_action_permissions`;
CREATE TABLE `sys_action_permissions` (
  `ap_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `ap_name` varchar(60) DEFAULT NULL COMMENT '操作名称',
  `ap_api` varchar(60) DEFAULT NULL COMMENT '操作接口名称',
  `ap_is_control` int(11) DEFAULT '0' COMMENT '是否接受权限控制 0-否 1-是',
  `ap_desc` varchar(100) DEFAULT NULL COMMENT '接口描述',
  `ap_method` varchar(30) DEFAULT NULL COMMENT '请求方式',
  `ap_note` varchar(100) DEFAULT NULL COMMENT '接口备注',
  `ap_is_delete` int(11) DEFAULT '0' COMMENT '是否删除 0-否 1-是',
  `ap_response_params` mediumtext COMMENT '返回参',
  `ap_is_auto` int(11) DEFAULT '0' COMMENT '是否自动构建 0-否 1-是',
  `ap_type` varchar(5) DEFAULT NULL COMMENT '构建类型 C-新增 U-更新 D-删除 R-查询',
  `ap_is_cache` int(11) DEFAULT '0' COMMENT '是否开启缓存 0-否 1-是',
  `ap_is_get_cache` int(11) DEFAULT '0' COMMENT '是否使用缓存 0-否 1-是',
  `ap_api_type` varchar(45) DEFAULT 'BUSSINESS' COMMENT '接口的类型 SYSTEM（系统接口）  BUSSINESS（业务接口）  EXTENSION（扩展接口）',
  `ap_auto_table` varchar(80) DEFAULT NULL COMMENT '自动构建的表名或视图名',
  `ap_cache_type` varchar(45) DEFAULT 'file' COMMENT '缓存的类型 file（文件缓存） memory（内存缓存）',
  `ap_apcid` int(11) DEFAULT '0' COMMENT '所属类别ID',
  `ap_fmid` int(11) DEFAULT '0' COMMENT '所属功能模块ID（仅仅是扩展模块时，此字段有意义）',
  PRIMARY KEY (`ap_id`)
) ENGINE=InnoDB AUTO_INCREMENT=361 DEFAULT CHARSET=utf8 COMMENT='操作权限表';

-- ----------------------------
-- Records of sys_action_permissions
-- ----------------------------
BEGIN;
INSERT INTO `sys_action_permissions` VALUES (318, '安装扩展功能模块', '/extensionApi/installExtension', 1, NULL, 'POTS', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (319, '安装扩展功能菜单', '/extensionApi/installExtensionMenu', 1, NULL, 'POTS', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (320, '卸载扩展功能菜单', '/extensionApi/uninstallExtensionMenu', 1, NULL, 'POTS', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (321, '卸载扩展功能模块', '/extensionApi/unInstallExtension', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (322, '删除扩展功能模块', '/function_module/delete', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (324, '删除原子层操作接口分类', '/menu_action_permissions_category/delete', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (326, '更新原子层操作接口分类', '/menu_action_permissions_category/update', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (328, '新增菜单', '/menu/add', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (329, '删除菜单', '/menu/delete', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (330, '更新菜单', '/menu/update', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (331, '菜单分配操作', '/systemApi/addMenuToAction', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (332, '新增组织架构', '/organizational_structure/add', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (333, '更新组织架构', '/organizational_structure/update', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (334, '删除组织架构', '/organizational_structure/delete', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (335, '新增角色', '/organizational_role/add', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (336, '删除角色', '/organizational_role/delete', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (337, '更新角色', '/organizational_role/update', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (338, '新增员工', '/user/add', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (339, '节点分配员工', '/systemApi/organizationalToEmployee', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (340, '更新员工信息', '/user/update', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (341, '操作分配给某权限中的菜单', '/role_menu_middle/update', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (342, '菜单分配角色', '/systemApi/addMenuToRole', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (343, '删除角色中的菜单', '/role_menu_middle/delete', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (344, '用户分配角色', '/systemApi/userAllocationRole', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (345, '节点分配角色', '/systemApi/organizationalAllocationRole', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (346, '节点分配角色（父子继承关系处理）', '/systemApi/organizationalInheritRole', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (347, '新增聚合层接口文档', '/systemApi/addBussinessApiDocs', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (348, '删除聚合层接口文档', '/bussiness_api_docs/delete', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (349, '更新聚合层接口文档', '/systemApi/updateAggregationApiDocs', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (350, '新增聚合层接口文档分类', '/bussiness_api_docs_category/add', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (351, '删除聚合层接口文档分类', '/bussiness_api_docs_category/delete', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (352, '编辑聚合层接口文档分类', '/bussiness_api_docs_category/update', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (353, '更新原子层服务配置文件', '/systemApi/updateConfiguration', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (354, '重新生成原子层配置文件', '/systemApi/rebuildConfiguration', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (355, '新增原子层操作接口', '/systemApi/addActionPermissions', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (356, '重新生成原子层接口配置文件', '/systemApi/rebuildBussinessApi', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (357, '删除原子层操作接口', '/systemApi/deleteActionPermissions', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (358, '更新原子层操作接口', '/systemApi/updateActionPermissions', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (359, '新增原子层操作接口分类', '/menu_action_permissions_category/add', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
INSERT INTO `sys_action_permissions` VALUES (360, '新增扩展功能模块', '/sys_organizational_function_module/add', 1, NULL, 'POST', NULL, 0, NULL, 0, NULL, 0, 0, 'SYSTEM', NULL, 'file', 50, 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_action_permissions_category
-- ----------------------------
DROP TABLE IF EXISTS `sys_action_permissions_category`;
CREATE TABLE `sys_action_permissions_category` (
  `apc_id` int(11) NOT NULL AUTO_INCREMENT,
  `apc_name` varchar(60) DEFAULT NULL COMMENT '类别名称',
  `apc_type` int(11) DEFAULT '0' COMMENT '类别类型 0-核心层业务接口 1-内置系统接口 2-扩展功能核心层接口 ',
  `apc_fmid` int(11) DEFAULT '0' COMMENT '关联模块ID  0-项目业务接口分类 ',
  PRIMARY KEY (`apc_id`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8 COMMENT='操作权限类别';

-- ----------------------------
-- Records of sys_action_permissions_category
-- ----------------------------
BEGIN;
INSERT INTO `sys_action_permissions_category` VALUES (50, '系统内置接口（system）', 1, 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_aggregation_server
-- ----------------------------
DROP TABLE IF EXISTS `sys_aggregation_server`;
CREATE TABLE `sys_aggregation_server` (
  `as_id` int(11) NOT NULL AUTO_INCREMENT,
  `as_name` varchar(45) DEFAULT NULL COMMENT '服务器名称',
  `as_no` varchar(45) DEFAULT NULL COMMENT '服务器编号',
  `as_is_open` int(11) DEFAULT '0' COMMENT '是否开启 0-否 1-是',
  `as_ip` varchar(45) DEFAULT NULL COMMENT '服务器IP地址',
  `as_port` varchar(30) DEFAULT NULL COMMENT '服务器端口号',
  `as_project_path` varchar(100) DEFAULT NULL COMMENT '项目所在目录',
  `as_is_show` int(11) DEFAULT '0' COMMENT '是否显示 0-否 1-是 （ 主管端不在此处显示 ）',
  PRIMARY KEY (`as_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='聚合层服务器表';

-- ----------------------------
-- Records of sys_aggregation_server
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_atomic_configuration
-- ----------------------------
DROP TABLE IF EXISTS `sys_atomic_configuration`;
CREATE TABLE `sys_atomic_configuration` (
  `ac_id` int(11) NOT NULL AUTO_INCREMENT,
  `ac_is_debug` int(11) DEFAULT '0',
  `ac_is_independent_deployment` int(11) DEFAULT '0',
  `ac_is_physically_delete` int(11) DEFAULT '0',
  `ac_is_access_control_allow_origin` int(11) DEFAULT '0',
  `ac_method` varchar(80) DEFAULT NULL,
  `ac_is_curd` int(11) DEFAULT '0',
  `ac_page_limit` int(11) DEFAULT '0',
  `ac_is_white_auth` int(11) DEFAULT '0',
  `ac_is_cache` int(11) DEFAULT '0',
  `ac_cache_type` varchar(60) DEFAULT NULL,
  `ac_cache_dir` varchar(60) DEFAULT NULL,
  `ac_cache_validity` int(11) DEFAULT '0',
  `ac_noDatabaseUse` int(11) DEFAULT '0',
  `ac_mysql_username` varchar(60) DEFAULT NULL,
  `ac_mysql_password` varchar(60) DEFAULT NULL,
  `ac_mysql_port` int(11) DEFAULT '0',
  `ac_mysql_host` varchar(80) DEFAULT NULL,
  `ac_mysql_dbname` varchar(60) DEFAULT NULL,
  `ac_mysql_prefix` varchar(60) DEFAULT NULL,
  `ac_mysql_view_prefix` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`ac_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='原子层服务器配置表';

-- ----------------------------
-- Records of sys_atomic_configuration
-- ----------------------------
BEGIN;
INSERT INTO `sys_atomic_configuration` VALUES (1, 1, 1, 1, 0, 'GET,POST,ALL', 1, 20, 0, 0, 'memory', 'cache', 3600, 0, 'liweixuan', '12345678', 3306, 'rm-2ze1kg3ip763wer90o.mysql.rds.aliyuncs.com', 'o_o', 'oo', 'v');
COMMIT;

-- ----------------------------
-- Table structure for sys_bussiness_api_docs
-- ----------------------------
DROP TABLE IF EXISTS `sys_bussiness_api_docs`;
CREATE TABLE `sys_bussiness_api_docs` (
  `bad_id` int(11) NOT NULL AUTO_INCREMENT,
  `bad_name` varchar(45) DEFAULT NULL COMMENT '接口名称',
  `bad_api` varchar(45) DEFAULT NULL COMMENT '接口地址',
  `bad_desc` varchar(100) DEFAULT NULL COMMENT '接口描述',
  `bad_method` varchar(45) DEFAULT NULL COMMENT '接口请求方式',
  `bad_note` varchar(100) DEFAULT NULL COMMENT '接口备注',
  `bad_is_delete` varchar(45) DEFAULT '0',
  `bad_response_params` mediumtext,
  `bad_badcid` int(11) DEFAULT '0' COMMENT '所属类别ID',
  `bad_type` int(11) DEFAULT '0' COMMENT '接口类型 0-自身业务接口 1-三方业务接口',
  `bad_fmid` int(11) DEFAULT '0' COMMENT '所属的模块ID（仅仅是扩展模块时，有意义）',
  PRIMARY KEY (`bad_id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COMMENT='业务层接口文档';

-- ----------------------------
-- Records of sys_bussiness_api_docs
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_bussiness_api_docs_category
-- ----------------------------
DROP TABLE IF EXISTS `sys_bussiness_api_docs_category`;
CREATE TABLE `sys_bussiness_api_docs_category` (
  `badc_id` int(11) NOT NULL AUTO_INCREMENT,
  `badc_name` varchar(60) DEFAULT NULL COMMENT '类别名称',
  `badc_fmid` int(11) DEFAULT '0' COMMENT '所属的模块ID 0-为自身业务分类',
  PRIMARY KEY (`badc_id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8 COMMENT='业务接口文档类别';

-- ----------------------------
-- Records of sys_bussiness_api_docs_category
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_bussiness_api_docs_request_parameter
-- ----------------------------
DROP TABLE IF EXISTS `sys_bussiness_api_docs_request_parameter`;
CREATE TABLE `sys_bussiness_api_docs_request_parameter` (
  `badrp_id` int(11) NOT NULL AUTO_INCREMENT,
  `badrp_badid` int(11) DEFAULT '0',
  `badrp_name` varchar(45) DEFAULT NULL,
  `badrp_is_must` int(11) DEFAULT '0',
  `badrp_rule` varchar(45) DEFAULT NULL,
  `badrp_note` varchar(45) DEFAULT NULL,
  `badrp_type` varchar(45) DEFAULT NULL,
  `badrp_way` varchar(45) DEFAULT NULL,
  `badrp_fmid` int(11) DEFAULT '0' COMMENT '功能模块ID 0-自身业务',
  PRIMARY KEY (`badrp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8 COMMENT='业务层请求参数表';

-- ----------------------------
-- Records of sys_bussiness_api_docs_request_parameter
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `m_id` int(11) NOT NULL AUTO_INCREMENT,
  `m_name` varchar(60) DEFAULT NULL COMMENT '菜单名称',
  `m_url` varchar(60) DEFAULT NULL COMMENT '菜单地址',
  `m_icon_type` int(11) DEFAULT '0' COMMENT '菜单的图标类型 0-字体图标 1-图片',
  `m_icon` varchar(60) DEFAULT NULL COMMENT '菜单的图标',
  `m_level` int(11) DEFAULT '0' COMMENT '菜单级别 0-一级菜单 1-二级菜单 2-三级菜单',
  `m_fid` int(11) DEFAULT '0' COMMENT '父菜单ID 0-一级菜单',
  `m_path` varchar(60) DEFAULT NULL COMMENT '菜单路径',
  `m_is_delete` int(11) DEFAULT '0' COMMENT '是否删除 0-否 1-是',
  `m_route_url` varchar(200) DEFAULT NULL COMMENT '路由文件地址',
  `m_is_show` int(11) DEFAULT '1' COMMENT '是否显示 0-否 1-是',
  `m_action_ids` varchar(80) DEFAULT NULL COMMENT '菜单所属基础操作',
  `m_type` int(11) DEFAULT '0' COMMENT '菜单类型 0-系统模块菜单 1-扩展模块菜单 2-业务模块菜单',
  `m_fmid` int(11) DEFAULT '0' COMMENT '所属的模块ID（仅仅为扩展菜单时，有意义）',
  PRIMARY KEY (`m_id`)
) ENGINE=InnoDB AUTO_INCREMENT=294 DEFAULT CHARSET=utf8 COMMENT='菜单表';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES (56, '系统管理', 'systemManager', 0, 'cogs', 0, 0, '0, ', 0, NULL, 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (57, '菜单管理', 'menuManager', 0, 'address-book-o', 1, 56, '0,56,', 0, NULL, 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (58, '组织架构管理', 'organizationalStructureManager', 0, 'bath', 1, 56, '0,56,', 0, NULL, 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (59, '添加菜单（开发环境使用）', 'addMenu', 0, 'bandcamp', 2, 57, '0,56,57,', 0, 'systemManager/menuManager/addMenu/addMenu.vue', 1, '', 0, 0);
INSERT INTO `sys_menu` VALUES (60, '添加组织架构', 'addOrganizationalStructure', 0, 'drivers-license', 2, 58, '0,56,58,', 0, 'systemManager/organizationalStructureManager/addOrganizationalStructure/addOrganizationalStructure.vue', 1, '', 0, 0);
INSERT INTO `sys_menu` VALUES (61, '组织架构列表', 'organizationalStructureList', 0, 'handshake-o', 2, 58, '0,56,58,', 0, 'systemManager/organizationalStructureManager/organizationalStructureList/OrganizationalStructureList.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (78, '菜单列表', 'menuList', 0, 'snowflake-o', 2, 57, '0,56,57,', 0, 'systemManager/menuManager/listMenu/listMenu.vue', 1, '', 0, 0);
INSERT INTO `sys_menu` VALUES (84, '角色管理', 'roleManager', 0, 'address-book', 1, 56, '0,56,', 0, NULL, 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (85, '新增角色', 'addRole', 0, 'address-book', 2, 84, '0,56,84,', 0, 'systemManager/roleManager/addRole/addRole.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (86, '原子层服务管理', 'atomicLayerServiceManager', 0, 'bandcamp', 1, 150, '0,150,', 0, NULL, 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (87, '服务器配置', 'serverConfiguration', 0, 'quora', 2, 86, '0,150,86,', 0, 'developmentManager/atomicLayerServiceManager/serverConfiguration/serverConfiguration.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (88, '项目文档管理', 'apiDocsManager', 0, 'external-link-square', 1, 149, '0,149,', 0, NULL, 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (92, '原子层文档预览', 'atomicLayerApiDocsList', 0, 'thermometer-3', 2, 274, '0,149,274,', 0, 'apiDocsManager/apiDocsPreview/atomicLayerApiDocsList/atomicLayerApiDocsList.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (93, '聚合层文档预览', 'aggregationLayerApiDocsList', 0, 'meetup', 2, 274, '0,149,274,', 0, 'apiDocsManager/apiDocsPreview/aggregationLayerApiDocsList/aggregationLayerApiDocsList.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (94, '原子层接口管理', 'atomicApiManager', 0, 'vcard', 1, 150, '0,150,', 0, NULL, 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (95, '新增原子层接口', 'addAtomicApi', 0, 'thermometer-quarter', 2, 94, '0,150,94,', 0, 'developmentManager/atomicApiManager/addAtomicApi/addAtomicApi.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (96, '员工管理', 'employeeManagement', 0, 'user-o', 1, 56, '0,56,', 0, NULL, 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (97, '新增员工', 'addEmployee', 0, 'user-circle', 2, 96, '0,56,96,', 0, 'systemManager/employeeManagement/addEmployee/addEmployee.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (138, '权限管理', 'permissionsManager', 0, 'unlock-alt', 1, 56, '0,56,', 0, '', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (139, '角色菜单管理', 'roleMenuManager', 0, 'no', 2, 138, '0,56,138,', 0, 'systemManager/permissionsManager/roleMenuManager/roleMenuManager.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (140, '原子层接口列表', 'atomicApiList', 0, 'no', 2, 94, '0,150,94,', 0, 'developmentManager/atomicApiManager/atomicApiList/atomicApiList.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (141, '新增原子层接口分类', 'addAtomicCategory', 0, 'no', 2, 94, '0,150,94,', 0, 'developmentManager/atomicApiManager/addAtomicCategory/addAtomicCategory.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (142, '用户角色管理', 'userRoleManagement', 0, 'no', 2, 138, '0,56,138,', 0, 'systemManager/permissionsManager/userRoleManagement/userRoleManagement.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (143, '节点角色管理', 'nodeRoleManagement', 0, 'no', 2, 138, '0,56,138,', 0, 'systemManager/permissionsManager/nodeRoleManagement/nodeRoleManagement.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (144, '员工节点管理', 'employeeNodeManager', 0, 'no', 2, 96, '0,56,96,', 0, 'systemManager/employeeManagement/employeeNodeManager/employeeNodeManager.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (147, '运维管理', 'operationsManager', 0, 'microchip', 0, 0, '0, ', 0, '0', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (148, '数据库管理', 'dbManager', 0, 'tasks', 0, 0, '0, ', 0, '0', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (149, '接口文档管理', 'apiDocsManager', 0, 'sticky-note', 0, 0, '0, ', 0, '0', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (150, '开发管理', 'developmentManager', 0, 'wrench', 0, 0, '0, ', 0, '0', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (151, '角色列表', 'roleList', 0, 'no', 2, 84, '0,56,84,', 0, 'systemManager/roleManager/roleList/roleList.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (153, '新增聚合层文档', 'addAggregationApiDocs', 0, 'no', 2, 88, '0,149,88,', 0, 'apiDocsManager/apiDocsManager/addAggregationApiDocs/addAggregationApiDocs.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (154, '框框商店', 'frameworkStore', 0, 'shopping-cart', 0, 0, '0, ', 0, '0', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (155, '代码超市', 'codeShop', 0, 'plug', 1, 154, '0,154,', 0, '0', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (156, '功能模块', 'functionModule', 0, 'no', 2, 155, '0,154,155,', 0, 'frameworkStore/codeShop/functionModule/functionModule.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (157, '扩展功能文档管理', 'extApiDocsManager', 0, 'cubes', 1, 149, '0,149,', 0, '0', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (158, '扩展功能文档预览', 'extFunctionApiDocsList', 0, 'no', 2, 157, '0,149,157,', 0, 'apiDocsManager/extApiDocsManager/extFunctionApiDocsList/extFunctionApiDocsList.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (170, '扩展模块管理', 'extensionFunctionModuleManager', 0, 'folder', 1, 150, '0,150,', 0, '0', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (171, '扩展模块列表', 'extensionFunctionModuleList', 0, 'no', 2, 170, '0,150,170,', 0, 'developmentManager/extensionFunctionModuleManager/extensionFunctionModuleList/extensionFunctionModuleList.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (253, '菜单操作管理', 'menuActionManager', 0, 'no', 2, 57, '0,56,57,', 0, 'systemManager/menuManager/menuActionManager/menuActionManager.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (266, '编辑组织架构', 'editOrganizationalStructure', 0, 'no', 3, 61, '0,56,58,61,', 0, 'systemManager/organizationalStructureManager/organizationalStructureList/editOrganizationalStructure/editOrganizationalStructure.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (267, '编辑角色', 'editRole', 0, 'no', 3, 151, '0,56,84,151,', 0, 'systemManager/roleManager/roleList/editRole/editRole.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (268, '编辑菜单', 'editMenu', 0, 'no', 3, 78, '0,56,57,78,', 0, 'systemManager/menuManager/listMenu/editMenu/editMenu.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (269, '员工列表', 'employeeList', 0, 'no', 2, 96, '0,56,96,', 0, 'systemManager/employeeManagement/employeeList/employeeList.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (270, '编辑员工', 'editEmployee', 0, 'no', 3, 269, '0,56,96,269,', 0, 'systemManager/employeeManagement/employeeList/editEmployee/editEmployee.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (271, '编辑原子层接口', 'editAtomicApi', 0, 'no', 3, 140, '0,150,94,140,', 0, 'developmentManager/atomicApiManager/atomicApiList/editAtomicApi/editAtomicApi.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (272, '原子层接口分类列表', 'atomicApiCategoryList', 0, 'no', 2, 94, '0,150,94,', 0, 'developmentManager/atomicApiManager/atomicApiCategoryList/atomicApiCategoryList.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (273, '编辑原子层接口分类', 'editAtomicApiCategory', 0, 'no', 3, 272, '0,150,94,272,', 0, 'developmentManager/atomicApiManager/atomicApiCategoryList/editAtomicApiCategory/editAtomicApiCategory.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (274, '接口文档预览', 'apiDocsPreview', 0, 'desktop', 1, 149, '0,149,', 0, '0', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (275, '聚合层文档列表', 'aggregationLayerApiDocsListManager', 0, 'no', 2, 88, '0,149,88,', 0, 'apiDocsManager/apiDocsManager/aggregationLayerApiDocsListManager/aggregationLayerApiDocsListManager.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (276, '编辑聚合层文档', 'editAggregationLayerApiDocs', 0, 'no', 3, 275, '0,149,88,275,', 0, 'apiDocsManager/apiDocsManager/aggregationLayerApiDocsListManager/editAggregationLayerApiDocs/editAggregationLayerApiDocs.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (277, '新增聚合层接口分类', 'addAggregationApiDocsCategory', 0, 'no', 2, 88, '0,149,88,', 0, 'apiDocsManager/apiDocsManager/addAggregationApiDocsCategory/addAggregationApiDocsCategory.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (278, '聚合层接口文档分类列表', 'aggregationApiDocsCategoryList', 0, 'no', 2, 88, '0,149,88,', 0, 'apiDocsManager/apiDocsManager/aggregationApiDocsCategoryList/aggregationApiDocsCategoryList.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (279, '编辑聚合层文档分类', 'editAggregationApiDocsCategory', 0, 'no', 3, 278, '0,149,88,278,', 0, 'apiDocsManager/apiDocsManager/aggregationApiDocsCategoryList/editAggregationApiDocsCategory/editAggregationApiDocsCategory.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (280, '组织架构图形', 'organizationalStructureGraphical', 0, 'no', 2, 58, '0,56,58,', 0, 'systemManager/organizationalStructureManager/organizationalStructureGraphical/organizationalStructureGraphical.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (286, '聚合层服务器管理', 'aggregationServerManager', 0, 'server', 1, 147, '0,147,', 0, '0', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (287, '聚合层服务器列表', 'aggregationServerList', 0, 'no', 2, 286, '0,147,286,', 0, 'operationsManager/aggregationServerManager/aggregationServerList/aggregationServerList.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (288, '新增聚合层服务器', 'addAggregationServer', 0, 'no', 2, 286, '0,147,286,', 0, 'operationsManager/aggregationServerManager/addAggregationServer/addAggregationServer.vue', 1, NULL, 0, 0);
INSERT INTO `sys_menu` VALUES (289, '编辑聚合层服务器', 'editAggregationServer', 0, 'no', 3, 287, '0,147,286,287,', 0, 'operationsManager/aggregationServerManager/aggregationServerList/editAggregationServer/editAggregationServer.vue', 1, NULL, 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_menu_action_permissions_middle
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu_action_permissions_middle`;
CREATE TABLE `sys_menu_action_permissions_middle` (
  `mapm_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `mapm_mid` int(11) DEFAULT '0' COMMENT '菜单ID',
  `mapm_apid` int(11) DEFAULT '0' COMMENT '操作权限ID',
  PRIMARY KEY (`mapm_id`)
) ENGINE=InnoDB AUTO_INCREMENT=85 DEFAULT CHARSET=utf8 COMMENT='菜单操作权限表';

-- ----------------------------
-- Records of sys_menu_action_permissions_middle
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu_action_permissions_middle` VALUES (45, 59, 328);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (46, 78, 329);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (47, 268, 330);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (48, 253, 331);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (49, 60, 332);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (50, 61, 334);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (51, 266, 333);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (52, 85, 335);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (53, 151, 336);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (54, 267, 337);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (55, 97, 338);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (56, 144, 339);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (57, 269, 340);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (58, 270, 340);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (59, 139, 341);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (60, 139, 342);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (61, 139, 343);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (62, 142, 344);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (63, 143, 345);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (64, 143, 346);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (65, 153, 347);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (66, 275, 348);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (67, 276, 349);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (68, 277, 350);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (69, 278, 351);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (70, 279, 352);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (71, 87, 353);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (72, 87, 354);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (73, 95, 355);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (74, 140, 357);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (75, 271, 358);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (76, 141, 359);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (77, 272, 324);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (78, 273, 326);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (79, 171, 318);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (80, 171, 319);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (81, 171, 320);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (82, 171, 321);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (83, 171, 322);
INSERT INTO `sys_menu_action_permissions_middle` VALUES (84, 156, 360);
COMMIT;

-- ----------------------------
-- Table structure for sys_organizational_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_organizational_role`;
CREATE TABLE `sys_organizational_role` (
  `or_id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `or_name` varchar(60) DEFAULT NULL COMMENT '角色名称',
  `or_is_delete` int(11) DEFAULT '0' COMMENT '是否删除 0-否 1-是',
  `or_is_all` int(11) DEFAULT '0' COMMENT '是否拥有全部权限（超级管理员角色）',
  PRIMARY KEY (`or_id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COMMENT='公司角色表';

-- ----------------------------
-- Records of sys_organizational_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_organizational_role` VALUES (1, '超级管理员', 0, 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_organizational_role_middle
-- ----------------------------
DROP TABLE IF EXISTS `sys_organizational_role_middle`;
CREATE TABLE `sys_organizational_role_middle` (
  `orm_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `orm_osid` int(11) DEFAULT '0' COMMENT '组织架构ID',
  `orm_orid` int(11) DEFAULT '0' COMMENT '角色ID',
  PRIMARY KEY (`orm_id`)
) ENGINE=InnoDB AUTO_INCREMENT=167 DEFAULT CHARSET=utf8 COMMENT='组织架构角色表（中间表）';

-- ----------------------------
-- Records of sys_organizational_role_middle
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_organizational_structure
-- ----------------------------
DROP TABLE IF EXISTS `sys_organizational_structure`;
CREATE TABLE `sys_organizational_structure` (
  `os_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `os_name` varchar(60) DEFAULT NULL COMMENT '节点名称',
  `os_path` varchar(60) DEFAULT NULL COMMENT '节点路径',
  `os_fid` int(11) DEFAULT '0' COMMENT '所属父节点ID 0-根节点',
  `os_is_delete` int(11) DEFAULT '0' COMMENT '是否删除 0-否 1-是',
  `os_is_inherit` int(11) DEFAULT '0' COMMENT '是否继承 0-否 1-是',
  PRIMARY KEY (`os_id`)
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8 COMMENT='公司组织架构节点表';

-- ----------------------------
-- Records of sys_organizational_structure
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_request_parameter
-- ----------------------------
DROP TABLE IF EXISTS `sys_request_parameter`;
CREATE TABLE `sys_request_parameter` (
  `rp_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `rp_apid` int(11) DEFAULT '0' COMMENT '关联操作表',
  `rp_name` varchar(60) DEFAULT NULL COMMENT '参数名称',
  `rp_is_must` int(11) DEFAULT '0' COMMENT '是否为必传参 0-否 1-是',
  `rp_rule` varchar(30) DEFAULT NULL COMMENT '验证规则',
  `rp_note` varchar(80) DEFAULT NULL COMMENT '备注信息',
  `rp_type` varchar(45) DEFAULT NULL COMMENT '请求参类型 varchar,int,boolean,array等',
  `rp_way` varchar(45) DEFAULT NULL COMMENT '请求方式 BODY或RESTFUL',
  `rp_fmid` int(11) DEFAULT '0' COMMENT '所属模块ID 0-为自身业务接口',
  PRIMARY KEY (`rp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1414 DEFAULT CHARSET=utf8 COMMENT='接口请求参数表';

-- ----------------------------
-- Records of sys_request_parameter
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu_middle
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu_middle`;
CREATE TABLE `sys_role_menu_middle` (
  `rmm_id` int(11) NOT NULL AUTO_INCREMENT,
  `rmm_orid` int(11) DEFAULT '0' COMMENT '角色ID',
  `rmm_mid` int(11) DEFAULT '0' COMMENT '菜单ID',
  `rmm_apids` varchar(100) DEFAULT NULL COMMENT '接口权限ID',
  PRIMARY KEY (`rmm_id`)
) ENGINE=InnoDB AUTO_INCREMENT=389 DEFAULT CHARSET=utf8 COMMENT='角色菜单表（中间表）';

-- ----------------------------
-- Records of sys_role_menu_middle
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `u_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `u_username` varchar(60) DEFAULT NULL COMMENT '用户帐号',
  `u_password` varchar(60) DEFAULT NULL COMMENT '用户密码',
  `u_nickname` varchar(60) DEFAULT NULL COMMENT '用户昵称',
  `u_phone` varchar(60) DEFAULT NULL COMMENT '绑定的手机号码',
  `u_email` varchar(60) DEFAULT NULL COMMENT '绑定的邮箱地址',
  `u_create_time` int(11) DEFAULT '0' COMMENT '创建时间',
  `u_is_activation` int(11) DEFAULT '0' COMMENT '是否激活 0-否 1-是',
  `u_is_delete` int(11) DEFAULT '0' COMMENT '是否删除 0-否 1-是',
  `u_is_admin` int(11) DEFAULT '0' COMMENT '是否为超级管理员 0-否 1-是',
  PRIMARY KEY (`u_id`),
  UNIQUE KEY `u_username_UNIQUE` (`u_username`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='用户表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES (1, 'root', '123456', '超管', '0', '0', 0, 1, 0, 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_organizational_middle
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_organizational_middle`;
CREATE TABLE `sys_user_organizational_middle` (
  `uom_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `uom_osid` int(11) DEFAULT '0' COMMENT '组织架构ID',
  `uom_uid` int(11) DEFAULT '0' COMMENT '用户ID',
  PRIMARY KEY (`uom_id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT='用户组织架构表（中间表）';

-- ----------------------------
-- Records of sys_user_organizational_middle
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role_middle
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role_middle`;
CREATE TABLE `sys_user_role_middle` (
  `urm_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `urm_uid` int(11) DEFAULT '0' COMMENT '用户ID',
  `urm_orid` int(11) DEFAULT '0' COMMENT '角色ID',
  PRIMARY KEY (`urm_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='用户角色表（中建表）';

-- ----------------------------
-- Records of sys_user_role_middle
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role_middle` VALUES (9, 1, 1);
COMMIT;

-- ----------------------------
-- Table structure for test_class
-- ----------------------------
DROP TABLE IF EXISTS `test_class`;
CREATE TABLE `test_class` (
  `cid` int(11) NOT NULL AUTO_INCREMENT,
  `cname` varchar(45) DEFAULT NULL,
  `c_create_time` int(11) DEFAULT '0',
  `c_is_delete` int(11) DEFAULT '0',
  PRIMARY KEY (`cid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='班级表';

-- ----------------------------
-- Records of test_class
-- ----------------------------
BEGIN;
INSERT INTO `test_class` VALUES (1, '大力班', 0, 0);
INSERT INTO `test_class` VALUES (2, '天才班', 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for test_class_student
-- ----------------------------
DROP TABLE IF EXISTS `test_class_student`;
CREATE TABLE `test_class_student` (
  `csid` int(11) NOT NULL AUTO_INCREMENT,
  `cs_cid` int(11) DEFAULT '0',
  `cs_sid` int(11) DEFAULT '0',
  `cs_is_delete` int(11) DEFAULT '0',
  `cs_create_time` int(11) DEFAULT '0',
  PRIMARY KEY (`csid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='班级学生表';

-- ----------------------------
-- Records of test_class_student
-- ----------------------------
BEGIN;
INSERT INTO `test_class_student` VALUES (1, 1, 2, 0, 0);
INSERT INTO `test_class_student` VALUES (2, 1, 3, 0, 0);
INSERT INTO `test_class_student` VALUES (3, 2, 4, 0, 0);
INSERT INTO `test_class_student` VALUES (4, 2, 5, 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for test_student
-- ----------------------------
DROP TABLE IF EXISTS `test_student`;
CREATE TABLE `test_student` (
  `sid` int(11) NOT NULL AUTO_INCREMENT,
  `sname` varchar(45) DEFAULT NULL,
  `sage` varchar(45) DEFAULT NULL,
  `s_is_delete` int(11) DEFAULT '0',
  `s_create_time` int(11) DEFAULT '0',
  PRIMARY KEY (`sid`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8 COMMENT='学生测试表';

-- ----------------------------
-- Records of test_student
-- ----------------------------
BEGIN;
INSERT INTO `test_student` VALUES (2, 'B', '2', 0, 0);
INSERT INTO `test_student` VALUES (3, 'C', '3', 0, 0);
INSERT INTO `test_student` VALUES (4, 'D', '4', 0, 0);
INSERT INTO `test_student` VALUES (5, 'E', '5', 0, 0);
INSERT INTO `test_student` VALUES (6, 'F', '6', 0, 0);
INSERT INTO `test_student` VALUES (7, 'G', '7', 0, 0);
INSERT INTO `test_student` VALUES (8, 'H', '8', 0, 0);
INSERT INTO `test_student` VALUES (9, 'Y', '9', 0, 0);
INSERT INTO `test_student` VALUES (10, 'J', '10', 0, 0);
INSERT INTO `test_student` VALUES (11, 'K', '11', 0, 0);
INSERT INTO `test_student` VALUES (12, 'L', '12', 0, 0);
INSERT INTO `test_student` VALUES (13, 'M', '13', 0, 0);
INSERT INTO `test_student` VALUES (14, 'N', '14', 0, 0);
INSERT INTO `test_student` VALUES (15, 'W', '15', 0, 0);
INSERT INTO `test_student` VALUES (16, 'P', '16', 0, 0);
INSERT INTO `test_student` VALUES (17, 'Q', '17', 0, 0);
INSERT INTO `test_student` VALUES (18, 'R', '18', 0, 0);
INSERT INTO `test_student` VALUES (19, 'S', '19', 0, 0);
INSERT INTO `test_student` VALUES (20, 'T', '20', 0, 0);
INSERT INTO `test_student` VALUES (21, 'Z', '21', 0, 0);
INSERT INTO `test_student` VALUES (32, NULL, NULL, 0, 0);
INSERT INTO `test_student` VALUES (33, NULL, NULL, 0, 0);
INSERT INTO `test_student` VALUES (34, NULL, NULL, 0, 0);
INSERT INTO `test_student` VALUES (35, 'sdsaa', '11', 0, 0);
INSERT INTO `test_student` VALUES (36, 'sdsaa', NULL, 0, 0);
INSERT INTO `test_student` VALUES (37, NULL, NULL, 0, 0);
COMMIT;

-- ----------------------------
-- View structure for system_v_menu_action_permissions_info
-- ----------------------------
DROP VIEW IF EXISTS `system_v_menu_action_permissions_info`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `system_v_menu_action_permissions_info` AS select `m`.`m_id` AS `m_id`,`m`.`m_name` AS `m_name`,`m`.`m_url` AS `m_url`,`m`.`m_icon_type` AS `m_icon_type`,`m`.`m_icon` AS `m_icon`,`m`.`m_level` AS `m_level`,`m`.`m_fid` AS `m_fid`,`m`.`m_path` AS `m_path`,`m`.`m_is_delete` AS `m_is_delete`,`m`.`m_route_url` AS `m_route_url`,`m`.`m_is_show` AS `m_is_show`,`ap`.`ap_id` AS `ap_id`,`ap`.`ap_name` AS `ap_name`,`ap`.`ap_api` AS `ap_api`,`ap`.`ap_is_control` AS `ap_is_control`,`ap`.`ap_desc` AS `ap_desc`,`ap`.`ap_method` AS `ap_method`,`ap`.`ap_note` AS `ap_note`,`ap`.`ap_is_delete` AS `ap_is_delete`,`ap`.`ap_response_params` AS `ap_response_params`,`ap`.`ap_is_auto` AS `ap_is_auto`,`ap`.`ap_type` AS `ap_type`,`ap`.`ap_is_cache` AS `ap_is_cache`,`ap`.`ap_is_get_cache` AS `ap_is_get_cache`,`ap`.`ap_api_type` AS `ap_api_type`,`ap`.`ap_auto_table` AS `ap_auto_table`,`ap`.`ap_cache_type` AS `ap_cache_type`,`ap`.`ap_apcid` AS `ap_apcid` from ((`sys_menu` `m` join `sys_action_permissions` `ap`) join `sys_menu_action_permissions_middle` `mapm`) where ((`m`.`m_id` = `mapm`.`mapm_mid`) and (`mapm`.`mapm_apid` = `ap`.`ap_id`));

-- ----------------------------
-- View structure for system_v_organizational_structure_role_info
-- ----------------------------
DROP VIEW IF EXISTS `system_v_organizational_structure_role_info`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `system_v_organizational_structure_role_info` AS select `os`.`os_id` AS `os_id`,`os`.`os_name` AS `os_name`,`os`.`os_path` AS `os_path`,`os`.`os_fid` AS `os_fid`,`os`.`os_is_delete` AS `os_is_delete`,`oor`.`or_id` AS `or_id`,`oor`.`or_name` AS `or_name`,`oor`.`or_is_delete` AS `or_is_delete`,`orm`.`orm_id` AS `orm_id`,`orm`.`orm_osid` AS `orm_osid`,`orm`.`orm_orid` AS `orm_orid` from ((`sys_organizational_structure` `os` join `sys_organizational_role` `oor`) join `sys_organizational_role_middle` `orm`) where ((`os`.`os_id` = `orm`.`orm_osid`) and (`oor`.`or_id` = `orm`.`orm_orid`));

-- ----------------------------
-- View structure for system_v_role_menu_info
-- ----------------------------
DROP VIEW IF EXISTS `system_v_role_menu_info`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `system_v_role_menu_info` AS select `m`.`m_id` AS `m_id`,`m`.`m_name` AS `m_name`,`m`.`m_url` AS `m_url`,`m`.`m_icon_type` AS `m_icon_type`,`m`.`m_icon` AS `m_icon`,`m`.`m_level` AS `m_level`,`m`.`m_fid` AS `m_fid`,`m`.`m_path` AS `m_path`,`m`.`m_is_delete` AS `m_is_delete`,`m`.`m_route_url` AS `m_route_url`,`m`.`m_is_show` AS `m_is_show`,`m`.`m_type` AS `m_type`,`oor`.`or_id` AS `or_id`,`oor`.`or_name` AS `or_name`,`oor`.`or_is_delete` AS `or_is_delete`,`oor`.`or_is_all` AS `or_is_all`,`rmm`.`rmm_id` AS `rmm_id`,`rmm`.`rmm_orid` AS `rmm_orid`,`rmm`.`rmm_mid` AS `rmm_mid`,`rmm`.`rmm_apids` AS `rmm_apids` from ((`sys_menu` `m` join `sys_organizational_role` `oor`) join `sys_role_menu_middle` `rmm`) where ((`m`.`m_id` = `rmm`.`rmm_mid`) and (`oor`.`or_id` = `rmm`.`rmm_orid`) and (`oor`.`or_is_delete` = 0) and (`m`.`m_is_delete` = 0));

-- ----------------------------
-- View structure for system_v_user_role_info
-- ----------------------------
DROP VIEW IF EXISTS `system_v_user_role_info`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `system_v_user_role_info` AS select `u`.`u_id` AS `u_id`,`u`.`u_username` AS `u_username`,`u`.`u_password` AS `u_password`,`u`.`u_nickname` AS `u_nickname`,`u`.`u_phone` AS `u_phone`,`u`.`u_email` AS `u_email`,`u`.`u_create_time` AS `u_create_time`,`u`.`u_is_activation` AS `u_is_activation`,`u`.`u_is_delete` AS `u_is_delete`,`r`.`or_id` AS `or_id`,`r`.`or_name` AS `or_name`,`r`.`or_is_delete` AS `or_is_delete`,`r`.`or_is_all` AS `or_is_all`,`urm`.`urm_id` AS `urm_id`,`urm`.`urm_uid` AS `urm_uid`,`urm`.`urm_orid` AS `urm_orid` from ((`sys_user` `u` join `sys_organizational_role` `r`) join `sys_user_role_middle` `urm`) where ((`u`.`u_id` = `urm`.`urm_uid`) and (`r`.`or_id` = `urm`.`urm_orid`) and (`u`.`u_is_delete` = 0) and (`r`.`or_is_delete` = 0));

-- ----------------------------
-- View structure for test_class_student_info
-- ----------------------------
DROP VIEW IF EXISTS `test_class_student_info`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `test_class_student_info` AS select `cs`.`csid` AS `csid`,`cs`.`cs_cid` AS `cs_cid`,`cs`.`cs_sid` AS `cs_sid`,`cs`.`cs_is_delete` AS `cs_is_delete`,`cs`.`cs_create_time` AS `cs_create_time`,`s`.`sid` AS `sid`,`s`.`sname` AS `sname`,`s`.`sage` AS `sage`,`s`.`s_is_delete` AS `s_is_delete`,`s`.`s_create_time` AS `s_create_time` from (`test_student` `s` join `test_class_student` `cs`) where (`s`.`sid` = `cs`.`cs_sid`);

SET FOREIGN_KEY_CHECKS = 1;